package com.gxa.mapper;

import com.gxa.pojo.*;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * @Author: wangyifan
 * @Date: 2021/12/02 11:52
 * @Description: $end$
 * @Version: V1.0
 */

public interface GoodsMapper {
     List<Goods> queryGoodsList(Integer params1, Integer params2) ;

    List<Integer> queryGt_id(@Param("gt_pno")String gt_pno,@Param("gt_name") String gt_name);

    List<Goodstype> queryGoodsType(@Param("gt_id")Integer gt_id);

    int addGoodsTypeGt_pno(String gt_name);

    int addGoodsTypeGt_name(String gt_pno, String gt_name);

    int updateGoodsTypeGt_pno(@Param("gt_id")Integer gt_id, @Param("gt_name")String gt_name);

    int updateGoodsTypeGt_name(@Param("gt_id")Integer gt_id, @Param("gt_pno")String gt_pno, @Param("gt_name")String gt_name);

    int deleteGoodsType(@Param("gt_id")Integer gt_id);

    int addGoods(Goods good);

    int updateGoods(Goods goods);

    List<Goods> searchGoods(@Param("gt_id")List<Integer> gt_id,@Param("goods_name")String goods_name,@Param("goods_descript") String goods_descript,@Param("goods_barcode") String goods_barcode,@Param("currentPage")Integer currentPage0,@Param("pageSize")Integer pageSize);

    Integer deleteGoods(Integer goods_id);

    List<Map> queryPurchase(@Param("currentPage")Integer currentPage0, @Param("pageSize") Integer pageSize);

    Integer addPurchase(Purchase purchase);

    Integer updateGoodsInventory(@Param("goods_id")Integer goods_id, @Param("pur_numb")Integer pur_numb);

    Integer deletePurchase(@Param("pur_id")Integer pur_id);

    List<Supply> querySupply(@Param("currentPage")Integer params1, @Param("pageSize")Integer pageSize);

    Integer addSupply(Supply supply);

    List<Supply> searchSupply(@Param("su_name") String su_name, @Param("su_cooperation")Integer su_cooperation, @Param("su_contact")String  su_contact, @Param("su_phone")String su_phone, @Param("su_tel")String su_tel, @Param("su_fax")String su_fax, @Param("su_we")String su_we,@Param("su_qq") String su_qq,@Param("su_email") String su_email,@Param("su_web") String su_web,@Param("su_pro") String su_pro,@Param("su_city") String su_city,@Param("addDate1") String addDate1, @Param("addDate2")String addDate2);

    List<Supply> searchSupply2(@Param("string")String string);

    Integer deleteSupply(Integer su_id);

    Integer updateSupply(Supply supply);

    List<Store_House> queryStoreHouse();

    Integer countDataBase(@Param("database")String database);

    Integer addStoreHouse(Store_House storeHouse);

    Integer updateStoreHouse(Store_House storeHouse);

    Integer deleteStoreHouse(@Param("sh_id")Integer sh_id);

    List<Map> queryOrderGoods(@Param("currentPage")Integer currentPage, @Param("pageSize")Integer pageSize);

    List<Payment> queryPayment();

    Integer batchDeleteGoods(@Param("goods_idList")List<Integer> goods_idList);

    Integer countSearch(@Param("gt_id")List<Integer> gt_id, @Param("goods_name")String goods_name,@Param("goods_descript") String goods_descript, @Param("goods_barcode")String goods_barcode);
}
